package com.hmall.mapper;

import com.hmall.model.MallProductForwardStock;
import com.hmall.util.MyMapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface MallProductForwardStockMapper extends MyMapper<MallProductForwardStock> {

    List<MallProductForwardStock> selectByLimit(@Param("materialCode") String materialCode, @Param("start") int start, @Param("end") int end);

    List<MallProductForwardStock> selectStockByLimit(@Param("model") String model, @Param("twisting") String twisting, @Param("grade") String grade, @Param("color") String color);

    Integer selectCountByLimit(@Param("materialCode") String materialCode);

    List<MallProductForwardStock> selectByMaterialCode(@Param("materialCode") String materialCode);

    MallProductForwardStock selectByOneMaterialCode(@Param("materialCode") String materialCode);

    List<String> selectFactoryByType(@Param("type") String subTypeName);

    List<String> selectByMaterialCodeWithLimit(@Param("materialCode") String materialCode, @Param("num") int i);

    MallProductForwardStock selectByMaterialCodeWithFac(@Param("materialCode") String materialCode, @Param("inventoryOrganization") String inventoryOrganization);

    int selectAllCount(@Param("materialCode") String materialCode);
}